#!/usr/bin/python
# -*- coding:utf-8 -*-
# -------------------------------------------------------
# @author  : 龍皓
# @time    : 2025/2/25 21:56
# @function: the script is used to do something.
# @version : 1.0.0
# -------------------------------------------------------
from sqlalchemy import Column, Integer, String, Text, TIMESTAMP, func
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class Jobs(Base):
    __tablename__ = 'jobs'

    id = Column(Integer, primary_key=True, comment="job id")
    jobName = Column(String, comment="职位名称")
    salaryDesc = Column(String, comment="薪资范围")
    jobLabels = Column(String, comment="职位标签")
    jobDegree = Column(String, comment="学历")
    cityName = Column(String, comment="城市")
    brandName = Column(String, comment="公司名")
    brandScaleName = Column(String, comment="公司规模")
    brandStageName = Column(String, comment="公司发展阶段")
    areaDistrict = Column(String, comment="所在地区")
    brandIndustry = Column(String, comment="公司行业")
    link = Column(String, comment="详情页链接")
    desc = Column(Text, comment="职位描述")
    channel_id = Column(Integer, comment="渠道id")
    created_at = Column(TIMESTAMP, server_default=func.now(), comment="创建时间")
    updated_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now(), comment="更新时间")
